From 785c6cc2616e4ee548fca4f844a6c0fe59a4bb9c Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 4 Aug 2026 17:30:06 +0000 Subject: [PATCH] Prevent use of special swelling source values in NON_BREC_SIGHTING_SOURCES --- .../sokwedb/tables/create/non_brec_sighting_sources.m4 | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/db/schemas/sokwedb/tables/create/non_brec_sighting_sources.m4 b/db/schemas/sokwedb/tables/create/non_brec_sighting_sources.m4 index 52e6ff3..f73ae52 100644 --- a/db/schemas/sokwedb/tables/create/non_brec_sighting_sources.m4 +++ b/db/schemas/sokwedb/tables/create/non_brec_sighting_sources.m4 @@ -27,6 +27,12 @@ CREATE TABLE non_brec_sighting_sources ( key_column(`NON_BREC_SIGHTING_SOURCES', `ID', INTEGER) ,source TEXT NOT NULL REFERENCES sighting_records + CONSTRAINT "Source may not be sdb_arrivals_a_source" + CHECK(source <> 'sdb_sdb_arrivals_a_source') + CONSTRAINT "Source may not be sdb_arrivals_source" + CHECK(source <> 'sdb_sdb_arrivals_source') + CONSTRAINT "Source may not be sdb_mating_source" + CHECK(source <> 'sdb_sdb_mating_source') ,date DATE NOT NULL ,animid_column() ,commid TEXT NOT NULL -- 2.34.1